The OData feed function allows users to capture a special URL or snippet that allows them to read in the result set of the item's query into another client technology that consumes data. This, in effect, turns Pyramid into a data source. Important: This feature should not be confused with the OData source option in Model, where Pyramid can consume other OData feeds.
Note: The OData Feed capability requires separate licensing.
Access the OData Feed URL
Tip: In addition to the following options, the OData Feed is also accessible to Basic users, who are given access to embedded content items only.
Content Manager
The OData function can be triggered using the quick action buttons on the Action Panel for discoveries (red highlight):
App Tabs
Alternatively, these options can also be accessed from a discovery's tab menu in the App Tab Interface (purple highlights below).
Runtime Presentation
In addition, you can copy the OData URL link or snippet for any visuals in a live presentation, to use in any other OData compliant tools. Simply right-click on the content and select the required OData option.
Note: This link might or might not be under Content Details. The structure of your context menu depends on your settings in User Defaults. For more information, see Context Menu.
The link or snippet is copied to the clipboard, and can be opened in other applications.
OData Options
- OData Link: copy the OData URL link for the item. The OData link enables connectivity with datasources like Excel using Windows or Basic authentication.
- OData Link without Filters: copy the OData URL link for the item, excluding filters.
- OData Snippet: copy the OData snippet for the item. Note: The snippet enables connectivity with datasources like Excel or Power BI using Web Token authentication.
- OData Snippet without Filters: copy the OData snippet for the item, excluding filters.
Warning: If you select to copy the link or snippet without filters, the returned data will not be limited by the Query Limits. Use at your own risk.
Using OData in Excel
Example: Using the OData Link in Excel
To use Pyramid data inside another tool, like Excel, copy one of the OData Link options. This will copy the special URL to your clipboard.
Next, switch to Excel, and open a new worksheet. From the Data tab, choose Get Data > From OData Feed (orange arrow below).
In the pop-up dialog, paste the URL into the box (CTRL+V) and click OK.
You will be prompted to supply your user credentials to login to Pyramid and access the data source. Pyramid supports Windows and Basic Authentication. Enter your credentials and click Connect.
You will then be prompted with a preview of the result set. Click Load to import the data.
Once imported, use the data as needed. At any time, right-click on the table to Refresh the data and re-pull updated results from Pyramid.
Example: Using the OData Snippet in Excel
If you want to use Pyramid data inside another tool but need to connect using web token authentication, you need to copy one of the OData Snippet options. This will copy the special snippet to your clipboard for use in Excel.
Next, switch to Excel, and open a new worksheet. Go to the Data tab, choose Get Data > From Other Sources > Blank Query.
Paste your snippet URL into the text box (red arrow):
Click Edit Credentials and, in the dialog that opens, select Web API (red arrow).
Copy the appropriate Authentication key from Pyramid to your clipboard:
- If you want to authenticate as the user that is currently logged in to Pyramid, go to the System Info page (purple arrow below) and click the Copy icon alongside the Authentication token (green arrow).
- If you are an administrator, you can authenticate as a different user via the Admin Console. For details, see Get Authentication Token.
Go back to the OData feed dialog in Excel, and paste the Authentication key into the Key field. Click Connect.
A preview of the result set opens in the Query Builder. Click Close & Load to import the data.